#coding=utf-8

import sys
sys.path.append("..")
from common.mysql.connect import MysqlConnector


def get_dict_of_mid_and_bid():
    """ 获取manager表和base_info表的关联关系，返回值是字典
    """
    # mysql_db = MysqlConnector()

    # sql = "SELECT id,zl_id FROM ko_manager WHERE zl_id > 0"
    # res = mysql_db.select(sql)
    res = {
        8: 110, 10: 111, 12: 112, 13: 1, 27: 113, 
        28: 2, 230: 409, 30: 114, 31: 115, 32: 116, 
        195: 243, 108: 4, 111: 190, 112: 3, 114: 5, 
        115: 119, 124: 120, 229: 408, 167: 121, 179: 276, 
        190: 272, 204: 274, 205: 273, 211: 273, 220: 356, 
        221: 358, 228: 378, 253: 449, 264: 273, 275: 275, 
        317: 5, 316: 110, 320: 582, 318: 116, 319: 115, 
        321: 585, 358: 678, 361: 680
    }
    return res


if __name__ == '__main__':
    dict_tmp = get_dict_of_mid_and_bid()
    print(dict_tmp)
    
    # dict = {}
    # for info in dict_tmp:
    #     # print(info['id'])
    #     dict[info['id']] = info['zl_id']
    # print(dict)

